Overview
Brought to you by YData
Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 19130 |
| Missing cells | 120 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.5 MiB |
| Average record size in memory | 192.0 B |
Variable types
| Categorical | 2 |
|---|---|
| DateTime | 4 |
| Text | 6 |
| Numeric | 11 |
| Boolean | 1 |
actual_distance_to_destination is highly overall correlated with actual_time and 4 other fields | High correlation |
actual_time is highly overall correlated with actual_distance_to_destination and 4 other fields | High correlation |
cutoff_factor is highly overall correlated with actual_distance_to_destination and 4 other fields | High correlation |
factor is highly overall correlated with segment_factor | High correlation |
osrm_distance is highly overall correlated with actual_distance_to_destination and 5 other fields | High correlation |
osrm_time is highly overall correlated with actual_distance_to_destination and 5 other fields | High correlation |
route_type is highly overall correlated with start_scan_to_end_scan | High correlation |
segment_actual_time is highly overall correlated with segment_osrm_distance and 1 other fields | High correlation |
segment_factor is highly overall correlated with factor | High correlation |
segment_osrm_distance is highly overall correlated with osrm_distance and 4 other fields | High correlation |
segment_osrm_time is highly overall correlated with segment_actual_time and 1 other fields | High correlation |
start_scan_to_end_scan is highly overall correlated with actual_distance_to_destination and 6 other fields | High correlation |
factor is highly skewed (γ1 = 20.41257294) | Skewed |
segment_factor is highly skewed (γ1 = 62.26346765) | Skewed |
segment_actual_time has 253 (1.3%) zeros | Zeros |
segment_osrm_time has 311 (1.6%) zeros | Zeros |
segment_osrm_distance has 207 (1.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-10-30 11:16:27.767197 |
|---|---|
| Analysis finished | 2024-10-30 11:17:13.775755 |
| Duration | 46.01 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 6.8901202 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | training |
|---|---|
| 2nd row | training |
| 3rd row | training |
| 4th row | training |
| 5th row | training |
Common Values
| Value | Count | Frequency (%) |
| training | 13822 | |
| test | 5308 | 27.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| training | 13822 | |
| test | 5308 | 27.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 27644 | |
| n | 27644 | |
| t | 24438 | |
| r | 13822 | |
| a | 13822 | |
| g | 13822 | |
| e | 5308 | 4.0% |
| s | 5308 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 131808 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 27644 | |
| n | 27644 | |
| t | 24438 | |
| r | 13822 | |
| a | 13822 | |
| g | 13822 | |
| e | 5308 | 4.0% |
| s | 5308 | 4.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 131808 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 27644 | |
| n | 27644 | |
| t | 24438 | |
| r | 13822 | |
| a | 13822 | |
| g | 13822 | |
| e | 5308 | 4.0% |
| s | 5308 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 131808 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 27644 | |
| n | 27644 | |
| t | 24438 | |
| r | 13822 | |
| a | 13822 | |
| g | 13822 | |
| e | 5308 | 4.0% |
| s | 5308 | 4.0% |
| Distinct | 2013 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
| Minimum | 2018-09-12 00:25:19.499696 |
|---|---|
| Maximum | 2018-10-03 23:59:42.701692 |
| Distinct | 962 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
Length
| Max length | 51 |
|---|---|
| Median length | 51 |
| Mean length | 51 |
| Min length | 51 |
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef |
|---|---|
| 2nd row | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef |
| 3rd row | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef |
| 4th row | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef |
| 5th row | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef |
| Value | Count | Frequency (%) |
| thanos::sroute:e2f5faaa-455a-494b-a501-549c3e3081ec | 278 | 1.5% |
| thanos::sroute:dca6268f-741a-4d1a-b1b0-aab13095a366 | 231 | 1.2% |
| thanos::sroute:0456b740-1dad-4929-bbe0-87d8843f5a10 | 231 | 1.2% |
| thanos::sroute:a4bf93af-8105-4dff-818e-cb79ddd69761 | 224 | 1.2% |
| thanos::sroute:366da0f3-1979-4793-973f-27da63568435 | 208 | 1.1% |
| thanos::sroute:162f9a67-5ebe-4338-8450-1c6d57d2c7b1 | 185 | 1.0% |
| thanos::sroute:fa83fd49-3327-4503-8e80-bf58ed636cc7 | 184 | 1.0% |
| thanos::sroute:67c77992-49e3-4594-9a75-9861ef082a00 | 183 | 1.0% |
| thanos::sroute:be1c03eb-fd2f-4455-a933-5e3d0857e027 | 179 | 0.9% |
| thanos::sroute:15c921f8-8a40-44cc-95ac-59f93d25f780 | 172 | 0.9% |
| Other values (952) | 17055 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 76520 | 7.8% |
| a | 63337 | 6.5% |
| : | 57390 | 5.9% |
| e | 55231 | 5.7% |
| 4 | 54618 | 5.6% |
| 9 | 41209 | 4.2% |
| 8 | 39098 | 4.0% |
| b | 39007 | 4.0% |
| 5 | 38356 | 3.9% |
| t | 38260 | 3.9% |
| Other values (15) | 472604 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 975630 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 76520 | 7.8% |
| a | 63337 | 6.5% |
| : | 57390 | 5.9% |
| e | 55231 | 5.7% |
| 4 | 54618 | 5.6% |
| 9 | 41209 | 4.2% |
| 8 | 39098 | 4.0% |
| b | 39007 | 4.0% |
| 5 | 38356 | 3.9% |
| t | 38260 | 3.9% |
| Other values (15) | 472604 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 975630 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 76520 | 7.8% |
| a | 63337 | 6.5% |
| : | 57390 | 5.9% |
| e | 55231 | 5.7% |
| 4 | 54618 | 5.6% |
| 9 | 41209 | 4.2% |
| 8 | 39098 | 4.0% |
| b | 39007 | 4.0% |
| 5 | 38356 | 3.9% |
| t | 38260 | 3.9% |
| Other values (15) | 472604 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 975630 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 76520 | 7.8% |
| a | 63337 | 6.5% |
| : | 57390 | 5.9% |
| e | 55231 | 5.7% |
| 4 | 54618 | 5.6% |
| 9 | 41209 | 4.2% |
| 8 | 39098 | 4.0% |
| b | 39007 | 4.0% |
| 5 | 38356 | 3.9% |
| t | 38260 | 3.9% |
| Other values (15) | 472604 |
route_type
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
| FTL | |
|---|---|
| Carting |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 4.2572922 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Carting |
|---|---|
| 2nd row | Carting |
| 3rd row | Carting |
| 4th row | Carting |
| 5th row | Carting |
Common Values
| Value | Count | Frequency (%) |
| FTL | 13117 | |
| Carting | 6013 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ftl | 13117 | |
| carting | 6013 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 13117 | |
| T | 13117 | |
| L | 13117 | |
| C | 6013 | |
| a | 6013 | |
| r | 6013 | |
| t | 6013 | |
| i | 6013 | |
| n | 6013 | |
| g | 6013 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 81442 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| F | 13117 | |
| T | 13117 | |
| L | 13117 | |
| C | 6013 | |
| a | 6013 | |
| r | 6013 | |
| t | 6013 | |
| i | 6013 | |
| n | 6013 | |
| g | 6013 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 81442 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| F | 13117 | |
| T | 13117 | |
| L | 13117 | |
| C | 6013 | |
| a | 6013 | |
| r | 6013 | |
| t | 6013 | |
| i | 6013 | |
| n | 6013 | |
| g | 6013 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 81442 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| F | 13117 | |
| T | 13117 | |
| L | 13117 | |
| C | 6013 | |
| a | 6013 | |
| r | 6013 | |
| t | 6013 | |
| i | 6013 | |
| n | 6013 | |
| g | 6013 |
trip_uuid
Text
| Distinct | 2013 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 23 |
| Mean length | 23.000366 |
| Min length | 23 |
Unique
| Unique | 50 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | trip-153741093647649320 |
|---|---|
| 2nd row | trip-153741093647649320 |
| 3rd row | trip-153741093647649320 |
| 4th row | trip-153741093647649320 |
| 5th row | trip-153741093647649320 |
| Value | Count | Frequency (%) |
| trip-153811219535896559 | 101 | 0.5% |
| trip-153854253003897121 | 79 | 0.4% |
| trip-153828994104597545 | 78 | 0.4% |
| trip-153796781323528185 | 78 | 0.4% |
| trip-153716182991453455 | 77 | 0.4% |
| trip-153841720103113533 | 77 | 0.4% |
| trip-153738046125722247 | 77 | 0.4% |
| trip-153716392193219844 | 77 | 0.4% |
| trip-153733496685379517 | 77 | 0.4% |
| trip-153846880073894675 | 77 | 0.4% |
| Other values (2003) | 18332 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 47087 | |
| 1 | 47006 | |
| 3 | 45553 | |
| 7 | 37077 | 8.4% |
| 8 | 31983 | 7.3% |
| 6 | 28971 | 6.6% |
| 9 | 27429 | 6.2% |
| 2 | 26494 | 6.0% |
| 0 | 26489 | 6.0% |
| 4 | 26258 | 6.0% |
| Other values (5) | 95650 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 439997 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5 | 47087 | |
| 1 | 47006 | |
| 3 | 45553 | |
| 7 | 37077 | 8.4% |
| 8 | 31983 | 7.3% |
| 6 | 28971 | 6.6% |
| 9 | 27429 | 6.2% |
| 2 | 26494 | 6.0% |
| 0 | 26489 | 6.0% |
| 4 | 26258 | 6.0% |
| Other values (5) | 95650 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 439997 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5 | 47087 | |
| 1 | 47006 | |
| 3 | 45553 | |
| 7 | 37077 | 8.4% |
| 8 | 31983 | 7.3% |
| 6 | 28971 | 6.6% |
| 9 | 27429 | 6.2% |
| 2 | 26494 | 6.0% |
| 0 | 26489 | 6.0% |
| 4 | 26258 | 6.0% |
| Other values (5) | 95650 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 439997 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5 | 47087 | |
| 1 | 47006 | |
| 3 | 45553 | |
| 7 | 37077 | 8.4% |
| 8 | 31983 | 7.3% |
| 6 | 28971 | 6.6% |
| 9 | 27429 | 6.2% |
| 2 | 26494 | 6.0% |
| 0 | 26489 | 6.0% |
| 4 | 26258 | 6.0% |
| Other values (5) | 95650 |
source_center
Text
| Distinct | 1048 |
|---|---|
| Distinct (%) | 5.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.6 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 11.999007 |
| Min length | 11 |
Unique
| Unique | 56 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | IND388121AAA |
|---|---|
| 2nd row | IND388121AAA |
| 3rd row | IND388121AAA |
| 4th row | IND388121AAA |
| 5th row | IND388121AAA |
| Value | Count | Frequency (%) |
| ind000000acb | 3248 | 17.0% |
| ind562132aaa | 1079 | 5.6% |
| ind421302aag | 980 | 5.1% |
| ind411033aaa | 588 | 3.1% |
| ind501359aae | 488 | 2.6% |
| ind560099aab | 316 | 1.7% |
| ind131028aab | 291 | 1.5% |
| ind160002aac | 280 | 1.5% |
| ind712311aaa | 260 | 1.4% |
| ind600056aab | 259 | 1.4% |
| Other values (1038) | 11341 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 43029 | |
| 0 | 40768 | |
| D | 19447 | |
| N | 19144 | |
| I | 19131 | |
| 1 | 16320 | 7.1% |
| 2 | 13213 | 5.8% |
| 3 | 11097 | 4.8% |
| 5 | 8438 | 3.7% |
| 4 | 8250 | 3.6% |
| Other values (17) | 30704 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 229541 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 43029 | |
| 0 | 40768 | |
| D | 19447 | |
| N | 19144 | |
| I | 19131 | |
| 1 | 16320 | 7.1% |
| 2 | 13213 | 5.8% |
| 3 | 11097 | 4.8% |
| 5 | 8438 | 3.7% |
| 4 | 8250 | 3.6% |
| Other values (17) | 30704 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 229541 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 43029 | |
| 0 | 40768 | |
| D | 19447 | |
| N | 19144 | |
| I | 19131 | |
| 1 | 16320 | 7.1% |
| 2 | 13213 | 5.8% |
| 3 | 11097 | 4.8% |
| 5 | 8438 | 3.7% |
| 4 | 8250 | 3.6% |
| Other values (17) | 30704 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 229541 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 43029 | |
| 0 | 40768 | |
| D | 19447 | |
| N | 19144 | |
| I | 19131 | |
| 1 | 16320 | 7.1% |
| 2 | 13213 | 5.8% |
| 3 | 11097 | 4.8% |
| 5 | 8438 | 3.7% |
| 4 | 8250 | 3.6% |
| Other values (17) | 30704 |
source_name
Text
| Distinct | 1044 |
|---|---|
| Distinct (%) | 5.5% |
| Missing | 61 |
| Missing (%) | 0.3% |
| Memory size | 149.6 KiB |
Length
| Max length | 44 |
|---|---|
| Median length | 41 |
| Mean length | 29.900729 |
| Min length | 8 |
Unique
| Unique | 57 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | Anand_VUNagar_DC (Gujarat) |
|---|---|
| 2nd row | Anand_VUNagar_DC (Gujarat) |
| 3rd row | Anand_VUNagar_DC (Gujarat) |
| 4th row | Anand_VUNagar_DC (Gujarat) |
| 5th row | Anand_VUNagar_DC (Gujarat) |
| Value | Count | Frequency (%) |
| haryana | 3905 | 9.2% |
| gurgaon_bilaspur_hb | 3248 | 7.6% |
| maharashtra | 2654 | 6.2% |
| karnataka | 2479 | 5.8% |
| pradesh | 2276 | 5.3% |
| tamil | 1093 | 2.6% |
| nadu | 1093 | 2.6% |
| bangalore_nelmngla_h | 1079 | 2.5% |
| bhiwandi_mankoli_hb | 980 | 2.3% |
| telangana | 900 | 2.1% |
| Other values (1085) | 22889 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 93643 | 16.4% |
| r | 41282 | 7.2% |
| _ | 37291 | 6.5% |
| n | 30665 | 5.4% |
| 23527 | 4.1% | |
| h | 23048 | 4.0% |
| l | 19642 | 3.4% |
| u | 19246 | 3.4% |
| ) | 19068 | 3.3% |
| ( | 19068 | 3.3% |
| Other values (57) | 243697 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 570177 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 93643 | 16.4% |
| r | 41282 | 7.2% |
| _ | 37291 | 6.5% |
| n | 30665 | 5.4% |
| 23527 | 4.1% | |
| h | 23048 | 4.0% |
| l | 19642 | 3.4% |
| u | 19246 | 3.4% |
| ) | 19068 | 3.3% |
| ( | 19068 | 3.3% |
| Other values (57) | 243697 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 570177 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 93643 | 16.4% |
| r | 41282 | 7.2% |
| _ | 37291 | 6.5% |
| n | 30665 | 5.4% |
| 23527 | 4.1% | |
| h | 23048 | 4.0% |
| l | 19642 | 3.4% |
| u | 19246 | 3.4% |
| ) | 19068 | 3.3% |
| ( | 19068 | 3.3% |
| Other values (57) | 243697 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 570177 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 93643 | 16.4% |
| r | 41282 | 7.2% |
| _ | 37291 | 6.5% |
| n | 30665 | 5.4% |
| 23527 | 4.1% | |
| h | 23048 | 4.0% |
| l | 19642 | 3.4% |
| u | 19246 | 3.4% |
| ) | 19068 | 3.3% |
| ( | 19068 | 3.3% |
| Other values (57) | 243697 |
| Distinct | 1036 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 149.6 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 11.999164 |
| Min length | 11 |
Unique
| Unique | 57 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | IND388620AAB |
|---|---|
| 2nd row | IND388620AAB |
| 3rd row | IND388620AAB |
| 4th row | IND388620AAB |
| 5th row | IND388620AAB |
| Value | Count | Frequency (%) |
| ind000000acb | 1717 | 9.0% |
| ind562132aaa | 1111 | 5.8% |
| ind421302aag | 849 | 4.4% |
| ind501359aae | 678 | 3.5% |
| ind411033aaa | 626 | 3.3% |
| ind712311aaa | 511 | 2.7% |
| ind131028aab | 461 | 2.4% |
| ind160002aac | 428 | 2.2% |
| ind751002aab | 396 | 2.1% |
| ind382430aab | 382 | 2.0% |
| Other values (1026) | 11970 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 45454 | |
| 0 | 33497 | |
| D | 19407 | |
| I | 19129 | |
| N | 19129 | |
| 1 | 18527 | |
| 2 | 14945 | 6.5% |
| 3 | 12383 | 5.4% |
| 5 | 9616 | 4.2% |
| 4 | 8093 | 3.5% |
| Other values (18) | 29352 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 229532 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 45454 | |
| 0 | 33497 | |
| D | 19407 | |
| I | 19129 | |
| N | 19129 | |
| 1 | 18527 | |
| 2 | 14945 | 6.5% |
| 3 | 12383 | 5.4% |
| 5 | 9616 | 4.2% |
| 4 | 8093 | 3.5% |
| Other values (18) | 29352 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 229532 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 45454 | |
| 0 | 33497 | |
| D | 19407 | |
| I | 19129 | |
| N | 19129 | |
| 1 | 18527 | |
| 2 | 14945 | 6.5% |
| 3 | 12383 | 5.4% |
| 5 | 9616 | 4.2% |
| 4 | 8093 | 3.5% |
| Other values (18) | 29352 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 229532 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 45454 | |
| 0 | 33497 | |
| D | 19407 | |
| I | 19129 | |
| N | 19129 | |
| 1 | 18527 | |
| 2 | 14945 | 6.5% |
| 3 | 12383 | 5.4% |
| 5 | 9616 | 4.2% |
| 4 | 8093 | 3.5% |
| Other values (18) | 29352 |
destination_name
Text
| Distinct | 1030 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 43 |
| Missing (%) | 0.2% |
| Memory size | 149.6 KiB |
Length
| Max length | 44 |
|---|---|
| Median length | 40 |
| Mean length | 30.038194 |
| Min length | 13 |
Unique
| Unique | 57 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | Khambhat_MotvdDPP_D (Gujarat) |
|---|---|
| 2nd row | Khambhat_MotvdDPP_D (Gujarat) |
| 3rd row | Khambhat_MotvdDPP_D (Gujarat) |
| 4th row | Khambhat_MotvdDPP_D (Gujarat) |
| 5th row | Khambhat_MotvdDPP_D (Gujarat) |
| Value | Count | Frequency (%) |
| maharashtra | 2653 | 6.1% |
| pradesh | 2650 | 6.1% |
| karnataka | 2617 | 6.0% |
| haryana | 2575 | 5.9% |
| gurgaon_bilaspur_hb | 1717 | 4.0% |
| tamil | 1136 | 2.6% |
| nadu | 1136 | 2.6% |
| bangalore_nelmngla_h | 1111 | 2.6% |
| gujarat | 1050 | 2.4% |
| telangana | 1047 | 2.4% |
| Other values (1069) | 25706 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 93038 | 16.2% |
| r | 39479 | 6.9% |
| _ | 37344 | 6.5% |
| n | 30242 | 5.3% |
| h | 24506 | 4.3% |
| 24311 | 4.2% | |
| ) | 19087 | 3.3% |
| ( | 19087 | 3.3% |
| l | 19028 | 3.3% |
| e | 18601 | 3.2% |
| Other values (56) | 248616 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 573339 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 93038 | 16.2% |
| r | 39479 | 6.9% |
| _ | 37344 | 6.5% |
| n | 30242 | 5.3% |
| h | 24506 | 4.3% |
| 24311 | 4.2% | |
| ) | 19087 | 3.3% |
| ( | 19087 | 3.3% |
| l | 19028 | 3.3% |
| e | 18601 | 3.2% |
| Other values (56) | 248616 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 573339 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 93038 | 16.2% |
| r | 39479 | 6.9% |
| _ | 37344 | 6.5% |
| n | 30242 | 5.3% |
| h | 24506 | 4.3% |
| 24311 | 4.2% | |
| ) | 19087 | 3.3% |
| ( | 19087 | 3.3% |
| l | 19028 | 3.3% |
| e | 18601 | 3.2% |
| Other values (56) | 248616 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 573339 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 93038 | 16.2% |
| r | 39479 | 6.9% |
| _ | 37344 | 6.5% |
| n | 30242 | 5.3% |
| h | 24506 | 4.3% |
| 24311 | 4.2% | |
| ) | 19087 | 3.3% |
| ( | 19087 | 3.3% |
| l | 19028 | 3.3% |
| e | 18601 | 3.2% |
| Other values (56) | 248616 |
od_start_time
Date
| Distinct | 3664 |
|---|---|
| Distinct (%) | 19.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 149.6 KiB |
| Minimum | 2018-09-12 00:39:30.747127 |
|---|---|
| Maximum | 2018-10-05 08:35:15.664489 |
od_end_time
Date
| Distinct | 3664 |
|---|---|
| Distinct (%) | 19.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 149.6 KiB |
| Minimum | 2018-09-12 01:32:05.649177 |
|---|---|
| Maximum | 2018-10-05 19:10:48.347039 |
start_scan_to_end_scan
Real number (ℝ)
High correlation 
| Distinct | 830 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 869.03131 |
| Minimum | 25 |
|---|---|
| Maximum | 3560 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 25 |
|---|---|
| 5-th percentile | 68 |
| Q1 | 149 |
| median | 402 |
| Q3 | 1352 |
| 95-th percentile | 3001 |
| Maximum | 3560 |
| Range | 3535 |
| Interquartile range (IQR) | 1203 |
Descriptive statistics
| Standard deviation | 962.42331 |
|---|---|
| Coefficient of variation (CV) | 1.1074668 |
| Kurtosis | 0.14039947 |
| Mean | 869.03131 |
| Median Absolute Deviation (MAD) | 303 |
| Skewness | 1.210742 |
| Sum | 16623700 |
| Variance | 926258.63 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3341 | 135 | 0.7% |
| 3178 | 113 | 0.6% |
| 86 | 79 | 0.4% |
| 3259 | 79 | 0.4% |
| 3116 | 78 | 0.4% |
| 2998 | 77 | 0.4% |
| 3042 | 77 | 0.4% |
| 136 | 77 | 0.4% |
| 2874 | 77 | 0.4% |
| 3001 | 77 | 0.4% |
| Other values (820) | 18260 |
| Value | Count | Frequency (%) |
| 25 | 2 | < 0.1% |
| 29 | 5 | < 0.1% |
| 30 | 2 | < 0.1% |
| 31 | 2 | < 0.1% |
| 32 | 7 | < 0.1% |
| 33 | 3 | < 0.1% |
| 34 | 14 | |
| 35 | 16 | |
| 36 | 14 | |
| 37 | 19 |
| Value | Count | Frequency (%) |
| 3560 | 67 | |
| 3341 | 135 | |
| 3259 | 79 | |
| 3230 | 77 | |
| 3178 | 113 | |
| 3116 | 78 | |
| 3114 | 60 | |
| 3113 | 54 | 0.3% |
| 3089 | 49 | 0.3% |
| 3056 | 77 |
is_cutoff
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 149.6 KiB |
| True | |
|---|---|
| False | |
| (Missing) | 1 |
| Value | Count | Frequency (%) |
| True | 15502 | |
| False | 3627 | 19.0% |
| (Missing) | 1 | < 0.1% |
cutoff_factor
Real number (ℝ)
High correlation 
| Distinct | 367 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 212.43128 |
| Minimum | 9 |
|---|---|
| Maximum | 1722 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 22 |
| median | 54 |
| Q3 | 242 |
| 95-th percentile | 990 |
| Maximum | 1722 |
| Range | 1713 |
| Interquartile range (IQR) | 220 |
Descriptive statistics
| Standard deviation | 325.97709 |
|---|---|
| Coefficient of variation (CV) | 1.534506 |
| Kurtosis | 4.2369428 |
| Mean | 212.43128 |
| Median Absolute Deviation (MAD) | 37 |
| Skewness | 2.1567782 |
| Sum | 4063598 |
| Variance | 106261.06 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22 | 1893 | 9.9% |
| 9 | 1648 | 8.6% |
| 44 | 1201 | 6.3% |
| 18 | 1120 | 5.9% |
| 66 | 801 | 4.2% |
| 27 | 763 | 4.0% |
| 88 | 602 | 3.1% |
| 110 | 495 | 2.6% |
| 36 | 469 | 2.5% |
| 132 | 428 | 2.2% |
| Other values (357) | 9709 |
| Value | Count | Frequency (%) |
| 9 | 1648 | |
| 10 | 59 | 0.3% |
| 11 | 59 | 0.3% |
| 12 | 46 | 0.2% |
| 13 | 46 | 0.2% |
| 14 | 69 | 0.4% |
| 15 | 78 | 0.4% |
| 16 | 81 | 0.4% |
| 17 | 61 | 0.3% |
| 18 | 1120 |
| Value | Count | Frequency (%) |
| 1722 | 1 | < 0.1% |
| 1720 | 1 | < 0.1% |
| 1716 | 2 | < 0.1% |
| 1694 | 4 | < 0.1% |
| 1690 | 1 | < 0.1% |
| 1689 | 10 | |
| 1688 | 1 | < 0.1% |
| 1687 | 1 | < 0.1% |
| 1672 | 15 | |
| 1650 | 15 |
cutoff_timestamp
Date
| Distinct | 17311 |
|---|---|
| Distinct (%) | 90.5% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 149.6 KiB |
| Minimum | 2018-09-12 00:47:25 |
|---|---|
| Maximum | 2018-10-05 17:12:00 |
actual_distance_to_destination
Real number (ℝ)
High correlation 
| Distinct | 19087 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 213.53329 |
| Minimum | 9.0002674 |
|---|---|
| Maximum | 1722.0098 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 9.0002674 |
|---|---|
| 5-th percentile | 9.664379 |
| Q1 | 23.086633 |
| median | 55.362397 |
| Q3 | 242.66601 |
| 95-th percentile | 991.36818 |
| Maximum | 1722.0098 |
| Range | 1713.0095 |
| Interquartile range (IQR) | 219.57938 |
Descriptive statistics
| Standard deviation | 326.18006 |
|---|---|
| Coefficient of variation (CV) | 1.5275373 |
| Kurtosis | 4.2328485 |
| Mean | 213.53329 |
| Median Absolute Deviation (MAD) | 37.656755 |
| Skewness | 2.1557363 |
| Sum | 4084678.2 |
| Variance | 106393.43 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44.26259134 | 2 | < 0.1% |
| 89.22987309 | 2 | < 0.1% |
| 22.69777197 | 2 | < 0.1% |
| 40.57180786 | 2 | < 0.1% |
| 9.574436922 | 2 | < 0.1% |
| 28.9936929 | 2 | < 0.1% |
| 68.65791654 | 2 | < 0.1% |
| 22.98932082 | 2 | < 0.1% |
| 10.00743576 | 2 | < 0.1% |
| 37.24074081 | 2 | < 0.1% |
| Other values (19077) | 19109 |
| Value | Count | Frequency (%) |
| 9.000267384 | 1 | |
| 9.000543467 | 1 | |
| 9.000990629 | 1 | |
| 9.001577078 | 1 | |
| 9.001647607 | 1 | |
| 9.002115228 | 1 | |
| 9.002821678 | 1 | |
| 9.00359161 | 1 | |
| 9.004551406 | 1 | |
| 9.004579901 | 1 |
| Value | Count | Frequency (%) |
| 1722.009755 | 1 | |
| 1720.765247 | 1 | |
| 1717.23169 | 1 | |
| 1716.603188 | 1 | |
| 1695.72981 | 1 | |
| 1694.671809 | 1 | |
| 1694.370209 | 1 | |
| 1694.277774 | 1 | |
| 1690.302865 | 1 | |
| 1689.847168 | 1 |
actual_time
Real number (ℝ)
High correlation 
| Distinct | 2206 |
|---|---|
| Distinct (%) | 11.5% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 377.0471 |
| Minimum | 9 |
|---|---|
| Maximum | 3276 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 50 |
| median | 119 |
| Q3 | 438 |
| 95-th percentile | 1709.6 |
| Maximum | 3276 |
| Range | 3267 |
| Interquartile range (IQR) | 388 |
Descriptive statistics
| Standard deviation | 552.51355 |
|---|---|
| Coefficient of variation (CV) | 1.4653701 |
| Kurtosis | 4.2758388 |
| Mean | 377.0471 |
| Median Absolute Deviation (MAD) | 87 |
| Skewness | 2.1575545 |
| Sum | 7212534 |
| Variance | 305271.22 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36 | 203 | 1.1% |
| 38 | 196 | 1.0% |
| 32 | 195 | 1.0% |
| 42 | 192 | 1.0% |
| 30 | 175 | 0.9% |
| 26 | 167 | 0.9% |
| 34 | 166 | 0.9% |
| 39 | 154 | 0.8% |
| 33 | 151 | 0.8% |
| 50 | 143 | 0.7% |
| Other values (2196) | 17387 |
| Value | Count | Frequency (%) |
| 9 | 13 | 0.1% |
| 10 | 17 | 0.1% |
| 11 | 36 | 0.2% |
| 12 | 72 | |
| 13 | 50 | 0.3% |
| 14 | 90 | |
| 15 | 92 | |
| 16 | 80 | |
| 17 | 85 | |
| 18 | 138 |
| Value | Count | Frequency (%) |
| 3276 | 1 | |
| 3219 | 1 | |
| 3180 | 1 | |
| 3162 | 1 | |
| 3102 | 1 | |
| 3066 | 1 | |
| 3033 | 1 | |
| 3031 | 1 | |
| 3003 | 1 | |
| 2973 | 1 |
osrm_time
Real number (ℝ)
High correlation 
| Distinct | 1277 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 196.26886 |
| Minimum | 6 |
|---|---|
| Maximum | 1611 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 26 |
| median | 59 |
| Q3 | 220 |
| 95-th percentile | 888.6 |
| Maximum | 1611 |
| Range | 1605 |
| Interquartile range (IQR) | 194 |
Descriptive statistics
| Standard deviation | 292.91788 |
|---|---|
| Coefficient of variation (CV) | 1.4924318 |
| Kurtosis | 4.6959924 |
| Mean | 196.26886 |
| Median Absolute Deviation (MAD) | 41 |
| Skewness | 2.2236541 |
| Sum | 3754427 |
| Variance | 85800.883 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 330 | 1.7% |
| 21 | 330 | 1.7% |
| 18 | 314 | 1.6% |
| 22 | 311 | 1.6% |
| 19 | 309 | 1.6% |
| 17 | 282 | 1.5% |
| 25 | 264 | 1.4% |
| 16 | 259 | 1.4% |
| 23 | 255 | 1.3% |
| 24 | 255 | 1.3% |
| Other values (1267) | 16220 |
| Value | Count | Frequency (%) |
| 6 | 24 | 0.1% |
| 7 | 102 | |
| 8 | 133 | |
| 9 | 157 | |
| 10 | 168 | |
| 11 | 239 | |
| 12 | 226 | |
| 13 | 228 | |
| 14 | 221 | |
| 15 | 167 |
| Value | Count | Frequency (%) |
| 1611 | 1 | < 0.1% |
| 1610 | 1 | < 0.1% |
| 1605 | 1 | < 0.1% |
| 1604 | 1 | < 0.1% |
| 1591 | 2 | |
| 1560 | 1 | < 0.1% |
| 1551 | 1 | < 0.1% |
| 1549 | 2 | |
| 1548 | 4 | |
| 1547 | 2 |
osrm_distance
Real number (ℝ)
High correlation 
| Distinct | 18849 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 260.53128 |
| Minimum | 9.1019 |
|---|---|
| Maximum | 2191.1664 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 9.1019 |
|---|---|
| 5-th percentile | 12.58666 |
| Q1 | 29.0895 |
| median | 71.8738 |
| Q3 | 291.8383 |
| 95-th percentile | 1212.98 |
| Maximum | 2191.1664 |
| Range | 2182.0645 |
| Interquartile range (IQR) | 262.7488 |
Descriptive statistics
| Standard deviation | 400.16469 |
|---|---|
| Coefficient of variation (CV) | 1.5359564 |
| Kurtosis | 4.6476729 |
| Mean | 260.53128 |
| Median Absolute Deviation (MAD) | 51.182 |
| Skewness | 2.223497 |
| Sum | 4983702.9 |
| Variance | 160131.78 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 26.8935 | 3 | < 0.1% |
| 48.7195 | 2 | < 0.1% |
| 10.7432 | 2 | < 0.1% |
| 175.319 | 2 | < 0.1% |
| 9.6941 | 2 | < 0.1% |
| 22.4752 | 2 | < 0.1% |
| 38.5491 | 2 | < 0.1% |
| 53.4168 | 2 | < 0.1% |
| 30.6035 | 2 | < 0.1% |
| 249.2718 | 2 | < 0.1% |
| Other values (18839) | 19108 |
| Value | Count | Frequency (%) |
| 9.1019 | 1 | |
| 9.1306 | 1 | |
| 9.1364 | 2 | |
| 9.1414 | 1 | |
| 9.202 | 1 | |
| 9.2256 | 1 | |
| 9.231 | 1 | |
| 9.2362 | 1 | |
| 9.24 | 1 | |
| 9.2441 | 1 |
| Value | Count | Frequency (%) |
| 2191.1664 | 1 | |
| 2189.8849 | 1 | |
| 2185.2996 | 1 | |
| 2185.1355 | 1 | |
| 2152.9283 | 1 | |
| 2152.903 | 1 | |
| 2129.7759 | 1 | |
| 2116.017 | 1 | |
| 2095.6729 | 1 | |
| 2091.6063 | 1 |
factor
Real number (ℝ)
High correlation  Skewed 
| Distinct | 9418 |
|---|---|
| Distinct (%) | 49.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0738659 |
| Minimum | 0.25 |
|---|---|
| Maximum | 77.387097 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 0.25 |
|---|---|
| 5-th percentile | 1.1666667 |
| Q1 | 1.5972851 |
| median | 1.8528897 |
| Q3 | 2.2068966 |
| 95-th percentile | 3.5454545 |
| Maximum | 77.387097 |
| Range | 77.137097 |
| Interquartile range (IQR) | 0.60961148 |
Descriptive statistics
| Standard deviation | 1.3699455 |
|---|---|
| Coefficient of variation (CV) | 0.66057576 |
| Kurtosis | 849.37163 |
| Mean | 2.0738659 |
| Median Absolute Deviation (MAD) | 0.29294367 |
| Skewness | 20.412573 |
| Sum | 39670.98 |
| Variance | 1.8767508 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 337 | 1.8% |
| 1.5 | 181 | 0.9% |
| 1.666666667 | 116 | 0.6% |
| 1.75 | 104 | 0.5% |
| 3 | 81 | 0.4% |
| 1.333333333 | 76 | 0.4% |
| 1 | 76 | 0.4% |
| 2.25 | 73 | 0.4% |
| 1.8 | 68 | 0.4% |
| 1.714285714 | 67 | 0.4% |
| Other values (9408) | 17950 |
| Value | Count | Frequency (%) |
| 0.25 | 1 | |
| 0.2727272727 | 1 | |
| 0.2941176471 | 1 | |
| 0.3440860215 | 1 | |
| 0.3529411765 | 1 | |
| 0.3537414966 | 1 | |
| 0.3880597015 | 1 | |
| 0.4 | 1 | |
| 0.4153846154 | 1 | |
| 0.4342105263 | 1 |
| Value | Count | Frequency (%) |
| 77.38709677 | 1 | |
| 66.38888889 | 1 | |
| 45.6875 | 1 | |
| 33.70588235 | 1 | |
| 32.9375 | 1 | |
| 31.2 | 1 | |
| 26.31818182 | 1 | |
| 22.92592593 | 1 | |
| 22.8 | 1 | |
| 21.20408163 | 1 |
segment_actual_time
Real number (ℝ)
High correlation  Zeros 
| Distinct | 311 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.495426 |
| Minimum | -26 |
|---|---|
| Maximum | 2297 |
| Zeros | 253 |
| Zeros (%) | 1.3% |
| Negative | 4 |
| Negative (%) | < 0.1% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | -26 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 20 |
| median | 29 |
| Q3 | 40 |
| 95-th percentile | 76 |
| Maximum | 2297 |
| Range | 2323 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 46.257 |
|---|---|
| Coefficient of variation (CV) | 1.303182 |
| Kurtosis | 449.4569 |
| Mean | 35.495426 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 15.416725 |
| Sum | 678992 |
| Variance | 2139.7101 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 789 | 4.1% |
| 26 | 680 | 3.6% |
| 30 | 618 | 3.2% |
| 28 | 581 | 3.0% |
| 36 | 576 | 3.0% |
| 32 | 572 | 3.0% |
| 27 | 557 | 2.9% |
| 23 | 514 | 2.7% |
| 12 | 508 | 2.7% |
| 25 | 469 | 2.5% |
| Other values (301) | 13265 |
| Value | Count | Frequency (%) |
| -26 | 1 | < 0.1% |
| -21 | 1 | < 0.1% |
| -5 | 1 | < 0.1% |
| -1 | 1 | < 0.1% |
| 0 | 253 | |
| 1 | 46 | 0.2% |
| 2 | 92 | 0.5% |
| 3 | 74 | 0.4% |
| 4 | 118 | |
| 5 | 119 |
| Value | Count | Frequency (%) |
| 2297 | 1 | |
| 1140 | 1 | |
| 1136 | 1 | |
| 1117 | 1 | |
| 1039 | 1 | |
| 1038 | 1 | |
| 990 | 1 | |
| 942 | 1 | |
| 901 | 1 | |
| 833 | 1 |
segment_osrm_time
Real number (ℝ)
High correlation  Zeros 
| Distinct | 126 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.404151 |
| Minimum | 0 |
|---|---|
| Maximum | 469 |
| Zeros | 311 |
| Zeros (%) | 1.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 11 |
| median | 17 |
| Q3 | 22 |
| 95-th percentile | 37 |
| Maximum | 469 |
| Range | 469 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 13.515165 |
|---|---|
| Coefficient of variation (CV) | 0.73435418 |
| Kurtosis | 150.74774 |
| Mean | 18.404151 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 7.0713552 |
| Sum | 352053 |
| Variance | 182.65969 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 1462 | 7.6% |
| 17 | 1349 | 7.1% |
| 18 | 1198 | 6.3% |
| 19 | 909 | 4.8% |
| 15 | 829 | 4.3% |
| 20 | 791 | 4.1% |
| 21 | 673 | 3.5% |
| 9 | 656 | 3.4% |
| 22 | 652 | 3.4% |
| 8 | 643 | 3.4% |
| Other values (116) | 9967 |
| Value | Count | Frequency (%) |
| 0 | 311 | |
| 1 | 179 | 0.9% |
| 2 | 185 | 1.0% |
| 3 | 250 | 1.3% |
| 4 | 280 | |
| 5 | 291 | |
| 6 | 530 | |
| 7 | 614 | |
| 8 | 643 | |
| 9 | 656 |
| Value | Count | Frequency (%) |
| 469 | 1 | |
| 407 | 1 | |
| 383 | 1 | |
| 234 | 1 | |
| 227 | 1 | |
| 221 | 1 | |
| 218 | 1 | |
| 184 | 1 | |
| 180 | 1 | |
| 174 | 1 |
segment_osrm_distance
Real number (ℝ)
High correlation  Zeros 
| Distinct | 18290 |
|---|---|
| Distinct (%) | 95.6% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.605794 |
| Minimum | 0 |
|---|---|
| Maximum | 635.1196 |
| Zeros | 207 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.16402 |
| Q1 | 11.9519 |
| median | 23.4432 |
| Q3 | 27.6426 |
| 95-th percentile | 42.8949 |
| Maximum | 635.1196 |
| Range | 635.1196 |
| Interquartile range (IQR) | 15.6907 |
Descriptive statistics
| Standard deviation | 16.018336 |
|---|---|
| Coefficient of variation (CV) | 0.70859428 |
| Kurtosis | 221.125 |
| Mean | 22.605794 |
| Median Absolute Deviation (MAD) | 7.5607 |
| Skewness | 8.4675763 |
| Sum | 432426.23 |
| Variance | 256.5871 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 207 | 1.1% |
| 12.7007 | 3 | < 0.1% |
| 22.9515 | 3 | < 0.1% |
| 27.1815 | 3 | < 0.1% |
| 25.771 | 3 | < 0.1% |
| 25.189 | 3 | < 0.1% |
| 24.4452 | 3 | < 0.1% |
| 24.2347 | 3 | < 0.1% |
| 22.8617 | 3 | < 0.1% |
| 22.4401 | 3 | < 0.1% |
| Other values (18280) | 18895 |
| Value | Count | Frequency (%) |
| 0 | 207 | |
| 0.011 | 1 | < 0.1% |
| 0.0194 | 1 | < 0.1% |
| 0.0198 | 1 | < 0.1% |
| 0.0509 | 1 | < 0.1% |
| 0.0842 | 1 | < 0.1% |
| 0.0931 | 1 | < 0.1% |
| 0.1177 | 1 | < 0.1% |
| 0.138 | 1 | < 0.1% |
| 0.1478 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 635.1196 | 1 | |
| 541.9036 | 1 | |
| 439.6047 | 1 | |
| 320.7535 | 1 | |
| 284.7385 | 1 | |
| 265.0528 | 1 | |
| 249.4472 | 1 | |
| 227.9952 | 1 | |
| 222.5406 | 1 | |
| 216.3338 | 1 |
segment_factor
Real number (ℝ)
High correlation  Skewed 
| Distinct | 2146 |
|---|---|
| Distinct (%) | 11.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2227136 |
| Minimum | -1.8571429 |
|---|---|
| Maximum | 574.25 |
| Zeros | 22 |
| Zeros (%) | 0.1% |
| Negative | 314 |
| Negative (%) | 1.6% |
| Memory size | 149.6 KiB |
Quantile statistics
| Minimum | -1.8571429 |
|---|---|
| 5-th percentile | 0.72727273 |
| Q1 | 1.35 |
| median | 1.6875 |
| Q3 | 2.25 |
| 95-th percentile | 4.3333333 |
| Maximum | 574.25 |
| Range | 576.10714 |
| Interquartile range (IQR) | 0.9 |
Descriptive statistics
| Standard deviation | 7.4267373 |
|---|---|
| Coefficient of variation (CV) | 3.3412929 |
| Kurtosis | 4497.771 |
| Mean | 2.2227136 |
| Median Absolute Deviation (MAD) | 0.41477273 |
| Skewness | 62.263468 |
| Sum | 42518.289 |
| Variance | 55.156427 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 815 | 4.3% |
| 1.5 | 617 | 3.2% |
| 1.333333333 | 324 | 1.7% |
| 1 | 319 | 1.7% |
| -1 | 311 | 1.6% |
| 1.666666667 | 304 | 1.6% |
| 3 | 243 | 1.3% |
| 1.75 | 233 | 1.2% |
| 1.6 | 185 | 1.0% |
| 2.5 | 176 | 0.9% |
| Other values (2136) | 15602 |
| Value | Count | Frequency (%) |
| -1.857142857 | 1 | < 0.1% |
| -1 | 311 | |
| -0.7 | 1 | < 0.1% |
| -0.4545454545 | 1 | < 0.1% |
| 0 | 22 | 0.1% |
| 0.03076923077 | 1 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.06172839506 | 1 | < 0.1% |
| 0.06896551724 | 1 | < 0.1% |
| 0.07692307692 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 574.25 | 1 | |
| 558.5 | 1 | |
| 493 | 1 | |
| 145 | 1 | |
| 122.2 | 1 | |
| 107 | 1 | |
| 83.66666667 | 1 | |
| 76.33333333 | 1 | |
| 72 | 2 | |
| 62.5 | 1 |
Interactions
Correlations
| actual_distance_to_destination | actual_time | cutoff_factor | data | factor | is_cutoff | osrm_distance | osrm_time | route_type | segment_actual_time | segment_factor | segment_osrm_distance | segment_osrm_time | start_scan_to_end_scan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| actual_distance_to_destination | 1.000 | 0.949 | 0.998 | 0.098 | 0.026 | 0.220 | 0.990 | 0.978 | 0.428 | 0.277 | -0.074 | 0.494 | 0.378 | 0.816 |
| actual_time | 0.949 | 1.000 | 0.950 | 0.101 | 0.235 | 0.196 | 0.957 | 0.954 | 0.422 | 0.362 | 0.049 | 0.462 | 0.359 | 0.821 |
| cutoff_factor | 0.998 | 0.950 | 1.000 | 0.098 | 0.029 | 0.219 | 0.990 | 0.978 | 0.428 | 0.273 | -0.072 | 0.486 | 0.372 | 0.815 |
| data | 0.098 | 0.101 | 0.098 | 1.000 | 0.000 | 0.016 | 0.099 | 0.098 | 0.034 | 0.007 | 0.000 | 0.010 | 0.000 | 0.233 |
| factor | 0.026 | 0.235 | 0.029 | 0.000 | 1.000 | 0.073 | 0.021 | -0.021 | 0.040 | 0.285 | 0.572 | -0.062 | -0.140 | 0.087 |
| is_cutoff | 0.220 | 0.196 | 0.219 | 0.016 | 0.073 | 1.000 | 0.220 | 0.219 | 0.144 | 0.079 | 0.044 | 0.000 | 0.000 | 0.328 |
| osrm_distance | 0.990 | 0.957 | 0.990 | 0.099 | 0.021 | 0.220 | 1.000 | 0.991 | 0.425 | 0.293 | -0.081 | 0.514 | 0.403 | 0.819 |
| osrm_time | 0.978 | 0.954 | 0.978 | 0.098 | -0.021 | 0.219 | 0.991 | 1.000 | 0.435 | 0.285 | -0.114 | 0.501 | 0.417 | 0.812 |
| route_type | 0.428 | 0.422 | 0.428 | 0.034 | 0.040 | 0.144 | 0.425 | 0.435 | 1.000 | 0.020 | 0.015 | 0.057 | 0.079 | 0.563 |
| segment_actual_time | 0.277 | 0.362 | 0.273 | 0.007 | 0.285 | 0.079 | 0.293 | 0.285 | 0.020 | 1.000 | 0.459 | 0.678 | 0.666 | 0.351 |
| segment_factor | -0.074 | 0.049 | -0.072 | 0.000 | 0.572 | 0.044 | -0.081 | -0.114 | 0.015 | 0.459 | 1.000 | -0.132 | -0.227 | -0.037 |
| segment_osrm_distance | 0.494 | 0.462 | 0.486 | 0.010 | -0.062 | 0.000 | 0.514 | 0.501 | 0.057 | 0.678 | -0.132 | 1.000 | 0.923 | 0.530 |
| segment_osrm_time | 0.378 | 0.359 | 0.372 | 0.000 | -0.140 | 0.000 | 0.403 | 0.417 | 0.079 | 0.666 | -0.227 | 0.923 | 1.000 | 0.423 |
| start_scan_to_end_scan | 0.816 | 0.821 | 0.815 | 0.233 | 0.087 | 0.328 | 0.819 | 0.812 | 0.563 | 0.351 | -0.037 | 0.530 | 0.423 | 1.000 |
Missing values
Sample
| data | trip_creation_time | route_schedule_uuid | route_type | trip_uuid | source_center | source_name | destination_center | destination_name | od_start_time | od_end_time | start_scan_to_end_scan | is_cutoff | cutoff_factor | cutoff_timestamp | actual_distance_to_destination | actual_time | osrm_time | osrm_distance | factor | segment_actual_time | segment_osrm_time | segment_osrm_distance | segment_factor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388121AAA | Anand_VUNagar_DC (Gujarat) | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | 2018-09-20 03:21:32.418600 | 2018-09-20 04:47:45.236797 | 86.0 | True | 9.0 | 2018-09-20 04:27:55 | 10.435660 | 14.0 | 11.0 | 11.9653 | 1.272727 | 14.0 | 11.0 | 11.9653 | 1.272727 |
| 1 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388121AAA | Anand_VUNagar_DC (Gujarat) | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | 2018-09-20 03:21:32.418600 | 2018-09-20 04:47:45.236797 | 86.0 | True | 18.0 | 2018-09-20 04:17:55 | 18.936842 | 24.0 | 20.0 | 21.7243 | 1.200000 | 10.0 | 9.0 | 9.7590 | 1.111111 |
| 2 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388121AAA | Anand_VUNagar_DC (Gujarat) | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | 2018-09-20 03:21:32.418600 | 2018-09-20 04:47:45.236797 | 86.0 | True | 27.0 | 2018-09-20 04:01:19.505586 | 27.637279 | 40.0 | 28.0 | 32.5395 | 1.428571 | 16.0 | 7.0 | 10.8152 | 2.285714 |
| 3 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388121AAA | Anand_VUNagar_DC (Gujarat) | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | 2018-09-20 03:21:32.418600 | 2018-09-20 04:47:45.236797 | 86.0 | True | 36.0 | 2018-09-20 03:39:57 | 36.118028 | 62.0 | 40.0 | 45.5620 | 1.550000 | 21.0 | 12.0 | 13.0224 | 1.750000 |
| 4 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388121AAA | Anand_VUNagar_DC (Gujarat) | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | 2018-09-20 03:21:32.418600 | 2018-09-20 04:47:45.236797 | 86.0 | False | 39.0 | 2018-09-20 03:33:55 | 39.386040 | 68.0 | 44.0 | 54.2181 | 1.545455 | 6.0 | 5.0 | 3.9153 | 1.200000 |
| 5 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | IND388320AAA | Anand_Vaghasi_IP (Gujarat) | 2018-09-20 04:47:45.236797 | 2018-09-20 06:36:55.627764 | 109.0 | True | 9.0 | 2018-09-20 06:15:58 | 10.403038 | 15.0 | 11.0 | 12.1171 | 1.363636 | 15.0 | 11.0 | 12.1171 | 1.363636 |
| 6 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | IND388320AAA | Anand_Vaghasi_IP (Gujarat) | 2018-09-20 04:47:45.236797 | 2018-09-20 06:36:55.627764 | 109.0 | True | 18.0 | 2018-09-20 05:47:29 | 18.045481 | 44.0 | 17.0 | 21.2890 | 2.588235 | 28.0 | 6.0 | 9.1719 | 4.666667 |
| 7 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | IND388320AAA | Anand_Vaghasi_IP (Gujarat) | 2018-09-20 04:47:45.236797 | 2018-09-20 06:36:55.627764 | 109.0 | True | 27.0 | 2018-09-20 05:25:58 | 28.061896 | 65.0 | 29.0 | 35.8252 | 2.241379 | 21.0 | 11.0 | 14.5362 | 1.909091 |
| 8 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | IND388320AAA | Anand_Vaghasi_IP (Gujarat) | 2018-09-20 04:47:45.236797 | 2018-09-20 06:36:55.627764 | 109.0 | True | 36.0 | 2018-09-20 05:15:56 | 38.939167 | 76.0 | 39.0 | 47.1900 | 1.948718 | 10.0 | 10.0 | 11.3648 | 1.000000 |
| 9 | training | 2018-09-20 02:35:36.476840 | thanos::sroute:eb7bfc78-b351-4c0e-a951-fa3d5c3297ef | Carting | trip-153741093647649320 | IND388620AAB | Khambhat_MotvdDPP_D (Gujarat) | IND388320AAA | Anand_Vaghasi_IP (Gujarat) | 2018-09-20 04:47:45.236797 | 2018-09-20 06:36:55.627764 | 109.0 | False | 43.0 | 2018-09-20 04:49:20 | 43.595802 | 102.0 | 45.0 | 53.2334 | 2.266667 | 26.0 | 6.0 | 6.0434 | 4.333333 |
| data | trip_creation_time | route_schedule_uuid | route_type | trip_uuid | source_center | source_name | destination_center | destination_name | od_start_time | od_end_time | start_scan_to_end_scan | is_cutoff | cutoff_factor | cutoff_timestamp | actual_distance_to_destination | actual_time | osrm_time | osrm_distance | factor | segment_actual_time | segment_osrm_time | segment_osrm_distance | segment_factor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19120 | test | 2018-10-03 21:30:56.518460 | thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780 | FTL | trip-153860225651817784 | IND842003AAB | Jabalpur_Adhartal_IP (Madhya Pradesh) | IND487001AAB | Narsinghpur_KndliDPP_D (Madhya Pradesh) | 2018-10-03 21:30:56.518460 | 2018-10-04 01:35:20.805767 | 244.0 | True | 22.0 | 2018-10-04 00:56:14 | 23.318250 | 30.0 | 25.0 | 26.9380 | 1.200000 | 30.0 | 25.0 | 26.9380 | 1.200000 |
| 19121 | test | 2018-10-03 21:30:56.518460 | thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780 | FTL | trip-153860225651817784 | IND842003AAB | Jabalpur_Adhartal_IP (Madhya Pradesh) | IND487001AAB | Narsinghpur_KndliDPP_D (Madhya Pradesh) | 2018-10-03 21:30:56.518460 | 2018-10-04 01:35:20.805767 | 244.0 | True | 44.0 | 2018-10-04 00:20:17 | 44.973964 | 65.0 | 47.0 | 50.5832 | 1.382979 | 35.0 | 21.0 | 23.6452 | 1.666667 |
| 19122 | test | 2018-10-03 21:30:56.518460 | thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780 | FTL | trip-153860225651817784 | IND842003AAB | Jabalpur_Adhartal_IP (Madhya Pradesh) | IND487001AAB | Narsinghpur_KndliDPP_D (Madhya Pradesh) | 2018-10-03 21:30:56.518460 | 2018-10-04 01:35:20.805767 | 244.0 | True | 66.0 | 2018-10-03 22:30:17 | 73.369213 | 175.0 | 74.0 | 86.5853 | 2.364865 | 110.0 | 27.0 | 36.0021 | 4.074074 |
| 19123 | test | 2018-10-03 21:30:56.518460 | thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780 | FTL | trip-153860225651817784 | IND842003AAB | Jabalpur_Adhartal_IP (Madhya Pradesh) | IND487001AAB | Narsinghpur_KndliDPP_D (Madhya Pradesh) | 2018-10-03 21:30:56.518460 | 2018-10-04 01:35:20.805767 | 244.0 | False | 84.0 | 2018-10-03 22:12:13 | 84.479723 | 194.0 | 80.0 | 94.6273 | 2.425000 | 18.0 | 8.0 | 12.4032 | 2.250000 |
| 19124 | test | 2018-10-03 21:30:56.518460 | thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780 | FTL | trip-153860225651817784 | IND487001AAB | Narsinghpur_KndliDPP_D (Madhya Pradesh) | IND487551AAA | Gadarwara_MPward_D (Madhya Pradesh) | 2018-10-04 01:57:29.964868 | 2018-10-04 03:16:19.550538 | 78.0 | True | 22.0 | 2018-10-04 02:38:17 | 23.142929 | 38.0 | 27.0 | 28.7071 | 1.407407 | 38.0 | 27.0 | 28.7071 | 1.407407 |
| 19125 | test | 2018-10-03 21:30:56.518460 | thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780 | FTL | trip-153860225651817784 | IND487001AAB | Narsinghpur_KndliDPP_D (Madhya Pradesh) | IND487551AAA | Gadarwara_MPward_D (Madhya Pradesh) | 2018-10-04 01:57:29.964868 | 2018-10-04 03:16:19.550538 | 78.0 | False | 41.0 | 2018-10-04 02:12:15 | 41.713301 | 64.0 | 48.0 | 52.3647 | 1.333333 | 26.0 | 20.0 | 23.6576 | 1.300000 |
| 19126 | test | 2018-10-03 21:30:56.518460 | thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780 | FTL | trip-153860225651817784 | IND487551AAA | Gadarwara_MPward_D (Madhya Pradesh) | IND464668AAA | Bareli_SourvDPP_D (Madhya Pradesh) | 2018-10-04 03:16:19.550538 | 2018-10-04 06:25:37.976768 | 189.0 | True | 22.0 | 2018-10-04 05:22:22 | 22.408595 | 48.0 | 34.0 | 31.5766 | 1.411765 | 48.0 | 34.0 | 31.5766 | 1.411765 |
| 19127 | test | 2018-10-03 21:30:56.518460 | thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780 | FTL | trip-153860225651817784 | IND487551AAA | Gadarwara_MPward_D (Madhya Pradesh) | IND464668AAA | Bareli_SourvDPP_D (Madhya Pradesh) | 2018-10-04 03:16:19.550538 | 2018-10-04 06:25:37.976768 | 189.0 | True | 44.0 | 2018-10-04 04:02:19 | 44.195324 | 128.0 | 67.0 | 80.9943 | 1.910448 | 80.0 | 39.0 | 41.4102 | 2.051282 |
| 19128 | test | 2018-10-03 21:30:56.518460 | thanos::sroute:0ac760f3-96cb-4046-bfd0-8bc467805780 | FTL | trip-153860225651817784 | IND487551AAA | Gadarwara_MPward_D (Madhya Pradesh) | IND464668AAA | Bareli_SourvDPP_D (Madhya Pradesh) | 2018-10-04 03:16:19.550538 | 2018-10-04 06:25:37.976768 | 189.0 | False | 57.0 | 2018-10-04 03:42:14 | 57.341503 | 148.0 | 62.0 | 75.0091 | 2.387097 | 20.0 | 18.0 | 18.2876 | 1.111111 |
| 19129 | training | 2018-09-21 06:43:44.036195 | thanos::sroute:9f229200-bc86-4418-90ae-653498358781 | Carting | trip-153751222403597152 | IND141003AAB | Ludhiana | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |